Sales location analysis

## # A tibble: 10 × 5
##    Zip   count med_Amount med_lat med_long
##    <chr> <int>      <dbl>   <dbl>    <dbl>
##  1 87101     1     14988.    35.7    -106.
##  2 87501    76      8181.    35.7    -106.
##  3 87502     2     11692.    35.6    -106.
##  4 87504     2      1954.    35.7    -106.
##  5 87505   157     10080.    35.6    -106.
##  6 87506    29     14251     35.7    -106.
##  7 87507   173      9631     35.6    -106.
##  8 87508    87     13832     35.6    -106.
##  9 87509     1     19156     35.8    -106.
## 10 87540     1     21360.    35.5    -106.

## # A tibble: 6 × 5
##   Zip   count med_Amount med_lat med_long
##   <chr> <int>      <dbl>   <dbl>    <dbl>
## 1 87112     2      6138.    35.2    -107.
## 2 87114     3      8535     35.3    -107.
## 3 87123     1      2489     35.2    -107.
## 4 87124   673      7800     35.3    -107.
## 5 87144   501      9275     35.3    -107.
## 6 87174     1      3265     35.3    -107.

## # A tibble: 27 × 5
##    Zip   count med_Amount med_lat med_long
##    <chr> <int>      <dbl>   <dbl>    <dbl>
##  1 87008     1     19381     35.1    -106.
##  2 87035     1      5464     34.9    -106.
##  3 87102    24      7808.    35.1    -107.
##  4 87103     1      4440     35.1    -107.
##  5 87104    35      8750     35.1    -107.
##  6 87105   134      7470.    35.0    -107.
##  7 87106    95      6417.    35.1    -107.
##  8 87107   119      8482     35.1    -107.
##  9 87108   134      7202.    35.1    -107.
## 10 87109   304      7434     35.2    -107.
## # ℹ 17 more rows

## Loading required package: lattice

## Loading required package: grid

## Loading required package: chron

Overall Sales

Variable	N	Mean	Std. Dev.	Min	Pctl. 25	Pctl. 75	Max
GrossAmount	7846	12134	11567	0	4764	15422	122703
Latitude	7846	35	0.38	32	35	35	38
Longitude	7846	-107	0.39	-109	-107	-107	-103

Albuquerque Sales

Variable	N	Mean	Std. Dev.	Min	Pctl. 25	Pctl. 75	Max
GrossAmount	4263	11070	11079	0	4163	13616	122703
Latitude	4263	35	0.049	35	35	35	35
Longitude	4263	-107	0.088	-107	-107	-107	-106

Rio Rancho Sales

Variable	N	Mean	Std. Dev.	Min	Pctl. 25	Pctl. 75	Max
GrossAmount	1181	11640	9981	0	5160	14836	67300
Latitude	1181	35	0.036	35	35	35	35
Longitude	1181	-107	0.055	-107	-107	-107	-106

Metro Area Sales

Variable	N	Mean	Std. Dev.	Min	Pctl. 25	Pctl. 75	Max
GrossAmount	529	14493	13257	0	5681	18892	100000
Latitude	529	36	0.054	35	36	36	36
Longitude	529	-106	0.053	-106	-106	-106	-106

Santa Fe Sales

Variable	N	Mean	Std. Dev.	Min	Pctl. 25	Pctl. 75	Max
GrossAmount
Latitude
Longtitude

## `geom_smooth()` using formula = 'y ~ x'

## 
## To cite package 'ggmap' in publications use:
## 
##   D. Kahle and H. Wickham. ggmap: Spatial Visualization with ggplot2.
##   The R Journal, 5(1), 144-161. URL
##   http://journal.r-project.org/archive/2013-1/kahle-wickham.pdf
## 
## A BibTeX entry for LaTeX users is
## 
##   @Article{,
##     author = {David Kahle and Hadley Wickham},
##     title = {ggmap: Spatial Visualization with ggplot2},
##     journal = {The R Journal},
##     year = {2013},
##     volume = {5},
##     number = {1},
##     pages = {144--161},
##     url = {https://journal.r-project.org/archive/2013-1/kahle-wickham.pdf},
##   }

## R version 4.2.2 (2022-10-31 ucrt)
## Platform: x86_64-w64-mingw32/x64 (64-bit)
## Running under: Windows 10 x64 (build 19045)
## 
## Matrix products: default
## 
## locale:
## [1] LC_COLLATE=English_United States.utf8 
## [2] LC_CTYPE=English_United States.utf8   
## [3] LC_MONETARY=English_United States.utf8
## [4] LC_NUMERIC=C                          
## [5] LC_TIME=English_United States.utf8    
## 
## attached base packages:
## [1] grid      stats     graphics  grDevices utils     datasets  methods  
## [8] base     
## 
## other attached packages:
##  [1] lattice_0.20-45      psych_2.3.3          vtable_1.4.4        
##  [4] kableExtra_1.3.4     lubridate_1.9.2      ggmap_3.0.2         
##  [7] rgdal_1.6-7          maptools_1.1-7       sp_1.6-1            
## [10] usmap_0.6.2          ggpointdensity_0.1.0 viridis_0.6.3       
## [13] viridisLite_0.4.2    tidyr_1.3.0          stringr_1.5.0       
## [16] dplyr_1.1.2          readxl_1.4.2         tidygeocoder_1.0.5  
## [19] ggplot2_3.4.2       
## 
## loaded via a namespace (and not attached):
##  [1] httr_1.4.6          sass_0.4.6          splines_4.2.2      
##  [4] jsonlite_1.8.5      bslib_0.5.0         highr_0.10         
##  [7] cellranger_1.1.0    yaml_2.3.7          pillar_1.9.0       
## [10] glue_1.6.2          digest_0.6.31       rvest_1.0.3        
## [13] colorspace_2.1-0    Matrix_1.5-1        htmltools_0.5.5    
## [16] plyr_1.8.8          pkgconfig_2.0.3     purrr_1.0.1        
## [19] scales_1.2.1        webshot_0.5.4       svglite_2.1.1      
## [22] jpeg_0.1-10         timechange_0.2.0    tibble_3.2.1       
## [25] mgcv_1.8-41         generics_0.1.3      farver_2.1.1       
## [28] sjlabelled_1.2.0    cachem_1.0.8        withr_2.5.0        
## [31] cli_3.6.1           mnormt_2.1.1        magrittr_2.0.3     
## [34] evaluate_0.21       fansi_1.0.4         nlme_3.1-160       
## [37] xml2_1.3.4          foreign_0.8-83      tools_4.2.2        
## [40] RgoogleMaps_1.4.5.3 lifecycle_1.0.3     munsell_0.5.0      
## [43] compiler_4.2.2      jquerylib_0.1.4     systemfonts_1.0.4  
## [46] rlang_1.1.1         rstudioapi_0.14     bitops_1.0-7       
## [49] labeling_0.4.2      rmarkdown_2.22      gtable_0.3.3       
## [52] R6_2.5.1            gridExtra_2.3       knitr_1.43         
## [55] fastmap_1.1.1       utf8_1.2.3          insight_0.19.2     
## [58] stringi_1.7.12      parallel_4.2.2      Rcpp_1.0.10        
## [61] vctrs_0.6.2         png_0.1-8           tidyselect_1.2.0   
## [64] xfun_0.39